<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dita PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<dita>
  <topic id="topic_qml_2rd_yz">
    <title>pgcrypto</title>
    <body>
      <p>Greenplum Database is installed with an optional module of encryption/decryption functions
        called <codeph>pgcrypto</codeph>. The <codeph>pgcrypto</codeph> functions allow database
        administrators to store certain columns of data in encrypted form. This adds an extra layer
        of protection for sensitive data, as data stored in Greenplum Database in encrypted form
        cannot be read by anyone who does not have the encryption key, nor can it be read directly
        from the disks.</p>
      <note>The <codeph>pgcrypto</codeph> functions run inside the database server, which means that
        all the data and passwords move between <codeph>pgcrypto</codeph> and the client application
        in clear-text. For optimal security, consider also using SSL connections between the client
        and the Greenplum master server.</note>
    </body>
    <topic id="topic_reg">
      <title>Installing and Registering the Module</title>
      <body>
        <p>The <codeph>pgcrypto</codeph> module is installed when you install Greenplum Database.
          Before you can use any of the functions defined in the module, you must register the
            <codeph>pgcrypto</codeph> extension in each database in which you want to use the
          functions. <ph otherprops="pivotal">Refer to <xref
              href="../../install_guide/install_modules.html" format="html" scope="external">Installing
              Additional Supplied Modules</xref> for more information.</ph></p>
      </body>
    </topic>
    <topic id="topic_info">
      <title>Additional Module Documentation</title>
      <body>
        <p>Refer to <xref href="https://www.postgresql.org/docs/9.4/pgcrypto.html" format="html"
          scope="external">pgcrypto</xref> in the PostgreSQL documentation for more information
          about the individual functions in this module.</p>
      </body>
    </topic>
  </topic>
</dita>
